[dbo].[asi_ComponentRegistryByNameAndInterface]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_ComponentRegistryByNameAndInterface

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@name	varchar(50)	50
@interface	varchar(100)	100

SQL Script

CREATE   PROC [dbo].[asi_ComponentRegistryByNameAndInterface]
@name varchar(50),
@interface varchar(100)
AS
BEGIN
    select ComponentKey, Description, InterfaceName, TypeName, AssemblyName, ConfigureWebUserControl, ConfigureWindowsControl from ComponentRegistry
where Name=@name and InterfaceName=@interface;

END

GO

Uses

[dbo].[ComponentRegistry]
dbo